create external table jms_dwd.dwd_tab_spec_piece_record_dt(
id               string   comment'id'
,billcode        string   comment'运单号'
,spec_type       string   comment'特殊件类型 "01"为正常件 "02"为生鲜件 "03"为拦截件 "04"为到付件 "05"为电联件 "06"按需派送 "07"为代收货款件 "08"为回单件 "09"送货上门'
,business_id     string   comment'品牌编号'
,business_name   string   comment'品牌名称'
,create_time     string   comment'创建时间'
)PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dwd.db/external/dwd_tab_spec_piece_record_dt'
TBLPROPERTIES (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);